--UTILITAIRES
INSERT INTO AU_PROVINCES VALUES (1,'FRANCAIS','ANGLAIS','0,05','0,095');
INSERT INTO AU_CLIENTS VALUES (SEQ_CLIENTID.NEXTVAL,'SIFLOU',1,'F','AL','FR','ROY','cLAUDE','M','ADRESE','QEFWEF','G4G 4K4', 'CANADA','(456) 666-6666','(456) 666-6666','EMAIL','ALLO','0');
INSERT INTO AU_MODELES VALUES ('ESCROTEE','ALLO','COUCOU',4.9,SYSDATE,4.6);
INSERT INTO AU_VEHICULES VALUES ('MAZD1201567','L888888','ESCROTEE','ALLO',8,100,1950,12345678.1234);
INSERT INTO AU_MODELES VALUES ('CX7','ALLO','COUCOU',4.9,SYSDATE,4.6);
INSERT INTO AU_VEHICULES VALUES ('MAZD2222222','L888888','CX7','ALLO',8,100,1950,12345678.1234);
INSERT INTO AU_OPTIONS VALUES (1,'OUI','NON');
INSERT INTO AU_OPTIONSDISPONIBLES VALUES (1,'ESCROTEE',2,123);
INSERT INTO AU_MODESFINANCEMENTS VALUES ('VISA', 'ALLO', 'COCO');

INSERT INTO AU_VENTESOPTIONS (VENTEID, OPTIONCD,MODECD,PRIXUNITAIREOPTION,QTEACHETEE)
VALUES (1,1,'ESCROTEE', 15.25,20);
select * from au_clients;
select * from au_ventes;
INSERT INTO AU_OPTIONS VALUES (3,'toit ouvrant','NON');
INSERT INTO AU_OPTIONSDISPONIBLES VALUES (2,'ESCROTEE',2,123);.


INSERT INTO AU_CLIENTS VALUES (SEQ_CLIENTID.NEXTVAL,'SIfleux',1,'F','AL','FR','ROY','cLAUDE','M','ADRESE','QEFWEF','G4G 4K4', 'CANADA','(456) 666-6666','(456) 666-6666','EMAIL','ALLO','0');

INSERT INTO AU_VENTESOPTIONS (VENTEID, OPTIONCD,MODECD,PRIXUNITAIREOPTION,QTEACHETEE)
VALUES (9,3,'ESCROTEE', 15.25,1);

select * from au_ventesoptions;
select * from au_vehicules;

INSERT INTO AU_VENTES (VENTEID, NOSERIEVEHICULE,CLIENTID, MODEFINCD, EMPLID, TAUXESCOMPTESAISONNIER,DATEVENTE,PRIXSUGGERE,
PRIXVENTEVEHICULE,ESCOMPTESAISONNIER,INDICATEURFIDELITE, TAUXESCOMPTEFIDELITE, COUTTOTALOPTION)
values(SEQ_VENTEID.NEXTVAL,'MAZD2222222',1,'VISA',2,0.32,'02/02/17',512.23,100,10.25,1,0.25,0);



INSERT INTO AU_OPTIONS VALUES (2,'toit ouvrant','NON');
INSERT INTO AU_OPTIONSDISPONIBLES VALUES (2,'CX7',2,123);

INSERT INTO AU_VENTES (VENTEID, NOSERIEVEHICULE,CLIENTID, MODEFINCD, EMPLID, TAUXESCOMPTESAISONNIER,DATEVENTE,PRIXSUGGERE,
PRIXVENTEVEHICULE,ESCOMPTESAISONNIER,INDICATEURFIDELITE, TAUXESCOMPTEFIDELITE, COUTTOTALOPTION)
values(SEQ_VENTEID.NEXTVAL,'MAZD1201567',4,'VISA',2,0.32,SYSDATE,512.23,100,10.25,1,0.25,0);

INSERT INTO AU_VENTES (VENTEID, NOSERIEVEHICULE,CLIENTID, MODEFINCD, EMPLID, TAUXESCOMPTESAISONNIER,DATEVENTE,PRIXSUGGERE,
PRIXVENTEVEHICULE,ESCOMPTESAISONNIER,INDICATEURFIDELITE, TAUXESCOMPTEFIDELITE, COUTTOTALOPTION)
values(SEQ_VENTEID.NEXTVAL,'MAZD1201567',1,'VISA',2,0.32,SYSDATE,512.23,200,10.25,1,0.25,150.12);
INSERT INTO AU_VENTES (VENTEID, NOSERIEVEHICULE,CLIENTID, MODEFINCD, EMPLID, TAUXESCOMPTESAISONNIER,DATEVENTE,PRIXSUGGERE,
PRIXVENTEVEHICULE,ESCOMPTESAISONNIER,INDICATEURFIDELITE, TAUXESCOMPTEFIDELITE, COUTTOTALOPTION)
values(SEQ_VENTEID.NEXTVAL,'MAZD1201567',2,'VISA',2,0.32,SYSDATE,512.23,2000,10.25,1,0.25,150.12);

INSERT INTO AU_CLIENTS VALUES (SEQ_CLIENTID.NEXTVAL,'pierre',1,'F','AL','FR','TROY','cLAUDE','M','ADRESE','QEFWEF','G4G 4K4', 'CANADA','(456) 666-6666','(456) 666-6666','EMAIL','ALLO','0');
--SELECT
SELECT * FROM USER_COL_COMMENTS;
SELECT * FROM AU_VEHICULES;
SELECT * FROM AU_CLIENTS;
SELECT * FROM AU_VENTES;
SELECT * FROM AU_VENTESOPTIONS;

--DELETE
DELETE FROM AU_VEHICULES;